<?php
include"arriba.html";
?>
<?php
include "db.php";
$search=$_REQUEST['searchc'];
$sql="SELECT * FROM st_club WHERE district LIKE '%$search%' OR areas LIKE '%$search%' OR division LIKE '%$search%' OR club_number LIKE '%$search%' OR club_name LIKE '%$search%' OR city LIKE '%$search%'";
$result = mysql_query($sql) or die( mysql_error());
$cuantos = mysql_num_rows($result);
if ($cuantos !=0 or $search='') {
	while ($fila = mysql_fetch_assoc($result)) {
	echo "<div class='datagrid'><table height='100'>
	<tr><td><b>".$fila['club_name']."</b>-Club #: ".$fila['club_number'].",Dist #: ".$fila['district']." Area: ".$fila['division'].$fila['areas'].", Est: ".$fila['charter_date']."</td><td>Acción</td></tr>
	<tr><td>".$fila['address1']."</td><td rowspan='2'><a href='change_club.php?idclub=".$fila['club_number']."'>Modificar</a></td></tr>
	<tr><td>".$fila['address2'].", ".$fila['club_name'].", ".$fila['estado_id'].", ".$fila['cp'].",".$fila['country']."</td></tr>
	<tr><td>".$fila['phone']."</td></tr>
	<tr><td>Meeting Time: ".$fila['meeting_time'].", ".$fila['meeting_day']."</td><td rowspan='2'>
	<a href='drop_club.php?idclub=".$fila['club_number']."'>Eliminar</a></td></tr>
	<tr><td>Club Status:  ".$fila['club_status']."</td></tr>";
	echo " </table></div><br><br>";
	}
}
else { 
echo"No se econtrarón resultados de la busqueda.";
}
<?php
include"abajo.html";
?>